2012-07-06 - 2897.1000 - Rel Notes - Open & Shipped Report #BIReleases2012

Release Notes

2897.1000 - Open & Shipped Report

Admin Info

---

Purpose	Open & Shipped Report
Release No	001
Submitted	07/06/2012
Submitted By	Narendra Koraganji
Source/Destination Systems	IT > BMS > Production to Public Folders / Reports / Sales Analysis
Release Sent To	Paul Gils
Object(s) Created By	Kevin Pitkin
Object(s) Tested By	Narendra Koraganji

Transport and Technical Objects

---

None

Release Notes

---

For Infrastructure

None

For Requestor

This report is going to be designed using SAP BEx queries to fetch current year revenue, Last year revenue, current year open value, Region, Country, Sales Rep and Customer values using the following formulas:
1. Calculating total (current year revenue + current year open).
2. Calculating variance between total and last year revenue.
3. Calculating coverage percentage on total and Last year revenue.
4. Using currency conversion files.

Reference Document(Specification)

---

2012-02-29 - 2897.1000 - Spec - Open & Shipped Report